<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<meta name="generator" content="Doxygen 1.8.6"/>
<title>SystemSharp: SQLite.SQLiteConnectionWithLock Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
  $(window).load(resizeHeight);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  <td id="projectlogo"><img alt="Logo" src="logo.png"/></td>
  <td style="padding-left: 0.5em;">
   <div id="projectname">SystemSharp
   &#160;<span id="projectnumber">0.3</span>
   </div>
   <div id="projectbrief">A system-level modeling framework for designing real-time embedded systems</div>
  </td>
 </tr>
 </tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.6 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Packages</span></a></li>
      <li class="current"><a href="annotated.html"><span>Classes</span></a></li>
      <li><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>Class&#160;List</span></a></li>
      <li><a href="classes.html"><span>Class&#160;Index</span></a></li>
      <li><a href="hierarchy.html"><span>Class&#160;Hierarchy</span></a></li>
      <li><a href="functions.html"><span>Class&#160;Members</span></a></li>
    </ul>
  </div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
      <div id="nav-sync" class="sync"></div>
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('class_s_q_lite_1_1_s_q_lite_connection_with_lock.html','');});
</script>
<div id="doc-content">
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&#160;</span>Typedefs</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(7)"><span class="SelectionMark">&#160;</span>Enumerations</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(8)"><span class="SelectionMark">&#160;</span>Enumerator</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(9)"><span class="SelectionMark">&#160;</span>Properties</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(10)"><span class="SelectionMark">&#160;</span>Events</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<div class="header">
  <div class="summary">
<a href="#nested-classes">Classes</a> &#124;
<a href="#pub-methods">Public Member Functions</a> &#124;
<a href="class_s_q_lite_1_1_s_q_lite_connection_with_lock-members.html">List of all members</a>  </div>
  <div class="headertitle">
<div class="title">SQLite.SQLiteConnectionWithLock Class Reference</div>  </div>
</div><!--header-->
<div class="contents">
<div class="dynheader">
Inheritance diagram for SQLite.SQLiteConnectionWithLock:</div>
<div class="dyncontent">
 <div class="center">
  <img src="class_s_q_lite_1_1_s_q_lite_connection_with_lock.png" usemap="#SQLite.SQLiteConnectionWithLock_map" alt=""/>
  <map id="SQLite.SQLiteConnectionWithLock_map" name="SQLite.SQLiteConnectionWithLock_map">
<area href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. " alt="SQLite.SQLiteConnection" shape="rect" coords="0,56,207,80"/>
</map>
 </div></div>
<table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
Public Member Functions</h2></td></tr>
<tr class="memitem:a49c8bfc343c53c30aa6195395958ffe2"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#a49c8bfc343c53c30aa6195395958ffe2">SQLiteConnectionWithLock</a> (<a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a> connectionString)</td></tr>
<tr class="separator:a49c8bfc343c53c30aa6195395958ffe2"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad38e795a2b94ecd709b9b60e2c4d3e4e"><td class="memItemLeft" align="right" valign="top">IDisposable&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html#ad38e795a2b94ecd709b9b60e2c4d3e4e">Lock</a> ()</td></tr>
<tr class="separator:ad38e795a2b94ecd709b9b60e2c4d3e4e"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="inherit_header pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td colspan="2" onclick="javascript:toggleInherit('pub_methods_class_s_q_lite_1_1_s_q_lite_connection')"><img src="closed.png" alt="-"/>&#160;Public Member Functions inherited from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLite.SQLiteConnection</a></td></tr>
<tr class="memitem:a21204da14d0e2a44039f3395bb4ff12d inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a21204da14d0e2a44039f3395bb4ff12d">SQLiteConnection</a> (string databasePath, bool storeDateTimeAsTicks=false)</td></tr>
<tr class="memdesc:a21204da14d0e2a44039f3395bb4ff12d inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath.  <a href="#a21204da14d0e2a44039f3395bb4ff12d">More...</a><br/></td></tr>
<tr class="separator:a21204da14d0e2a44039f3395bb4ff12d inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5d0deb6299d3f479e53cf81899023457 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a5d0deb6299d3f479e53cf81899023457">SQLiteConnection</a> (string databasePath, <a class="el" href="namespace_s_q_lite.html#a9d72cc097c53dbc96a6f0eec530cc439">SQLiteOpenFlags</a> openFlags, bool storeDateTimeAsTicks=false)</td></tr>
<tr class="memdesc:a5d0deb6299d3f479e53cf81899023457 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Constructs a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html" title="Represents an open connection to a SQLite database. ">SQLiteConnection</a> and opens a <a class="el" href="namespace_s_q_lite.html">SQLite</a> database specified by databasePath.  <a href="#a5d0deb6299d3f479e53cf81899023457">More...</a><br/></td></tr>
<tr class="separator:a5d0deb6299d3f479e53cf81899023457 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a25b7a6e9e1fa2e2ead47bb1821822fc6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a25b7a6e9e1fa2e2ead47bb1821822fc6">GetMapping</a> (Type type)</td></tr>
<tr class="memdesc:a25b7a6e9e1fa2e2ead47bb1821822fc6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the mapping that is automatically generated for the given type.  <a href="#a25b7a6e9e1fa2e2ead47bb1821822fc6">More...</a><br/></td></tr>
<tr class="separator:a25b7a6e9e1fa2e2ead47bb1821822fc6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:adf0ed08567e1ca36e4fda72c94ede544 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#adf0ed08567e1ca36e4fda72c94ede544">GetMapping&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:adf0ed08567e1ca36e4fda72c94ede544 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Retrieves the mapping that is automatically generated for the given type.  <a href="#adf0ed08567e1ca36e4fda72c94ede544">More...</a><br/></td></tr>
<tr class="separator:adf0ed08567e1ca36e4fda72c94ede544 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a783032226b2db2ebd6417f21abe9cd5a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a783032226b2db2ebd6417f21abe9cd5a">DropTable&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:a783032226b2db2ebd6417f21abe9cd5a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "drop table" on the database. This is non-recoverable.  <a href="#a783032226b2db2ebd6417f21abe9cd5a">More...</a><br/></td></tr>
<tr class="separator:a783032226b2db2ebd6417f21abe9cd5a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1a76c62e25bff4f6bbf5366175ab3bf7 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1a76c62e25bff4f6bbf5366175ab3bf7">CreateTable&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:a1a76c62e25bff4f6bbf5366175ab3bf7 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.  <a href="#a1a76c62e25bff4f6bbf5366175ab3bf7">More...</a><br/></td></tr>
<tr class="separator:a1a76c62e25bff4f6bbf5366175ab3bf7 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3e1bbdd7aebce4f815ca35b8277e1270 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a3e1bbdd7aebce4f815ca35b8277e1270">CreateTable</a> (Type ty)</td></tr>
<tr class="memdesc:a3e1bbdd7aebce4f815ca35b8277e1270 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes a "create table if not exists" on the database. It also creates any specified indexes on the columns of the table. It uses a schema automatically generated from the specified type. You can later access this schema by calling GetMapping.  <a href="#a3e1bbdd7aebce4f815ca35b8277e1270">More...</a><br/></td></tr>
<tr class="separator:a3e1bbdd7aebce4f815ca35b8277e1270 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af85031e61990a4d11d10533da5acb21c inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_1_1_column_info.html">ColumnInfo</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af85031e61990a4d11d10533da5acb21c">GetTableInfo</a> (string tableName)</td></tr>
<tr class="separator:af85031e61990a4d11d10533da5acb21c inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a112ac999fccd302bda742992f044f3ee inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top"><a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a112ac999fccd302bda742992f044f3ee">CreateCommand</a> (string cmdText, params object[] ps)</td></tr>
<tr class="memdesc:a112ac999fccd302bda742992f044f3ee inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text with arguments. Place a '?' in the command text for each of the arguments.  <a href="#a112ac999fccd302bda742992f044f3ee">More...</a><br/></td></tr>
<tr class="separator:a112ac999fccd302bda742992f044f3ee inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a5fbb3e385d21cfbee95e4a2a71a3043b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a5fbb3e385d21cfbee95e4a2a71a3043b">Execute</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:a5fbb3e385d21cfbee95e4a2a71a3043b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. Use this method instead of Query when you don't expect rows back. Such cases include INSERTs, UPDATEs, and DELETEs. You can set the Trace or TimeExecution properties of the connection to profile execution.  <a href="#a5fbb3e385d21cfbee95e4a2a71a3043b">More...</a><br/></td></tr>
<tr class="separator:a5fbb3e385d21cfbee95e4a2a71a3043b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af88acbe7da213c81875c3a35a5d61337 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af88acbe7da213c81875c3a35a5d61337">ExecuteScalar&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="separator:af88acbe7da213c81875c3a35a5d61337 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ade363948abe65a6b97fe8574f943db91 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">List&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ade363948abe65a6b97fe8574f943db91">Query&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:ade363948abe65a6b97fe8574f943db91 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.  <a href="#ade363948abe65a6b97fe8574f943db91">More...</a><br/></td></tr>
<tr class="separator:ade363948abe65a6b97fe8574f943db91 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a334b139ead4620ad13b5e1d54e8077af inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a334b139ead4620ad13b5e1d54e8077af">DeferredQuery&lt; T &gt;</a> (string query, params object[] args)</td></tr>
<tr class="memdesc:a334b139ead4620ad13b5e1d54e8077af inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the mapping automatically generated for the given type.  <a href="#a334b139ead4620ad13b5e1d54e8077af">More...</a><br/></td></tr>
<tr class="separator:a334b139ead4620ad13b5e1d54e8077af inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aeac8a5ef1be5cfabc5bbf33f1fec01b0 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">List&lt; object &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aeac8a5ef1be5cfabc5bbf33f1fec01b0">Query</a> (<a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map, string query, params object[] args)</td></tr>
<tr class="memdesc:aeac8a5ef1be5cfabc5bbf33f1fec01b0 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.  <a href="#aeac8a5ef1be5cfabc5bbf33f1fec01b0">More...</a><br/></td></tr>
<tr class="separator:aeac8a5ef1be5cfabc5bbf33f1fec01b0 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab359d97e7938a573e0a565d2c46aa401 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; object &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab359d97e7938a573e0a565d2c46aa401">DeferredQuery</a> (<a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map, string query, params object[] args)</td></tr>
<tr class="memdesc:ab359d97e7938a573e0a565d2c46aa401 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a> given the command text (SQL) with arguments. Place a '?' in the command text for each of the arguments and then executes that command. It returns each row of the result using the specified mapping. This function is only used by libraries in order to query the database via introspection. It is normally not used.  <a href="#ab359d97e7938a573e0a565d2c46aa401">More...</a><br/></td></tr>
<tr class="separator:ab359d97e7938a573e0a565d2c46aa401 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab44d5100216c3cdcea76e45c6f7d6246 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">TableQuery&lt; T &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab44d5100216c3cdcea76e45c6f7d6246">Table&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:ab44d5100216c3cdcea76e45c6f7d6246 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns a queryable interface to the table represented by the given type.  <a href="#ab44d5100216c3cdcea76e45c6f7d6246">More...</a><br/></td></tr>
<tr class="separator:ab44d5100216c3cdcea76e45c6f7d6246 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a17fdec8364635853d573e84530e1ab48 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a17fdec8364635853d573e84530e1ab48">Get&lt; T &gt;</a> (object pk)</td></tr>
<tr class="memdesc:a17fdec8364635853d573e84530e1ab48 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#a17fdec8364635853d573e84530e1ab48">More...</a><br/></td></tr>
<tr class="separator:a17fdec8364635853d573e84530e1ab48 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a4034d4b62385b2ab7451c5404ffb5efa inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a4034d4b62385b2ab7451c5404ffb5efa">Get&lt; T &gt;</a> (Expression&lt; Func&lt; T, bool &gt;&gt; predicate)</td></tr>
<tr class="memdesc:a4034d4b62385b2ab7451c5404ffb5efa inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.  <a href="#a4034d4b62385b2ab7451c5404ffb5efa">More...</a><br/></td></tr>
<tr class="separator:a4034d4b62385b2ab7451c5404ffb5efa inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:adfe66fe8c304aca8575f07fc1c05d9f5 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#adfe66fe8c304aca8575f07fc1c05d9f5">Find&lt; T &gt;</a> (object pk)</td></tr>
<tr class="memdesc:adfe66fe8c304aca8575f07fc1c05d9f5 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#adfe66fe8c304aca8575f07fc1c05d9f5">More...</a><br/></td></tr>
<tr class="separator:adfe66fe8c304aca8575f07fc1c05d9f5 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a95729c5ebf5fad75631109db91e7c14b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">object&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a95729c5ebf5fad75631109db91e7c14b">Find</a> (object pk, <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> map)</td></tr>
<tr class="memdesc:a95729c5ebf5fad75631109db91e7c14b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve an object with the given primary key from the table associated with the specified type. Use of this method requires that the given type have a designated PrimaryKey (using the <a class="el" href="class_s_q_lite_1_1_primary_key_attribute.html">PrimaryKeyAttribute</a>).  <a href="#a95729c5ebf5fad75631109db91e7c14b">More...</a><br/></td></tr>
<tr class="separator:a95729c5ebf5fad75631109db91e7c14b inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">T&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca">Find&lt; T &gt;</a> (Expression&lt; Func&lt; T, bool &gt;&gt; predicate)</td></tr>
<tr class="memdesc:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Attempts to retrieve the first object that matches the predicate from the table associated with the specified type.  <a href="#aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca">More...</a><br/></td></tr>
<tr class="separator:aeba2ae3cf5c1ffcb0c7eec7f8ccc64ca inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:aba3becdb524808bd49f349587f1b7049 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049">BeginTransaction</a> ()</td></tr>
<tr class="memdesc:aba3becdb524808bd49f349587f1b7049 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Begins a new transaction. Call <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a> to end the transaction.  <a href="#aba3becdb524808bd49f349587f1b7049">More...</a><br/></td></tr>
<tr class="separator:aba3becdb524808bd49f349587f1b7049 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab571412a681990a95131ded731ad6c4a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a">SaveTransactionPoint</a> ()</td></tr>
<tr class="memdesc:ab571412a681990a95131ded731ad6c4a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress.  <a href="#ab571412a681990a95131ded731ad6c4a">More...</a><br/></td></tr>
<tr class="separator:ab571412a681990a95131ded731ad6c4a inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a70cfe1d5799d71ce3a0a62c244bb7ea8 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a70cfe1d5799d71ce3a0a62c244bb7ea8">Rollback</a> ()</td></tr>
<tr class="memdesc:a70cfe1d5799d71ce3a0a62c244bb7ea8 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Rolls back the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>.  <a href="#a70cfe1d5799d71ce3a0a62c244bb7ea8">More...</a><br/></td></tr>
<tr class="separator:a70cfe1d5799d71ce3a0a62c244bb7ea8 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a94674fbf861328e85a249dd8c14ef6ea inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a94674fbf861328e85a249dd8c14ef6ea">RollbackTo</a> (string savepoint)</td></tr>
<tr class="memdesc:a94674fbf861328e85a249dd8c14ef6ea inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Rolls back the savepoint created by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> or SaveTransactionPoint.  <a href="#a94674fbf861328e85a249dd8c14ef6ea">More...</a><br/></td></tr>
<tr class="separator:a94674fbf861328e85a249dd8c14ef6ea inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a6813c9dd152354284ccdc96353bcfbdd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a6813c9dd152354284ccdc96353bcfbdd">Release</a> (string savepoint)</td></tr>
<tr class="memdesc:a6813c9dd152354284ccdc96353bcfbdd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Releases a savepoint returned from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab571412a681990a95131ded731ad6c4a" title="Creates a savepoint in the database at the current point in the transaction timeline. Begins a new transaction if one is not in progress. ">SaveTransactionPoint</a>. Releasing a savepoint makes changes since that savepoint permanent if the savepoint began the transaction, or otherwise the changes are permanent pending a call to <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>.  <a href="#a6813c9dd152354284ccdc96353bcfbdd">More...</a><br/></td></tr>
<tr class="separator:a6813c9dd152354284ccdc96353bcfbdd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a2c8187a19b5065f6b23c079e7cca29fe inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe">Commit</a> ()</td></tr>
<tr class="memdesc:a2c8187a19b5065f6b23c079e7cca29fe inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Commits the transaction that was begun by <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a>.  <a href="#a2c8187a19b5065f6b23c079e7cca29fe">More...</a><br/></td></tr>
<tr class="separator:a2c8187a19b5065f6b23c079e7cca29fe inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9132bae9e577ae479ddc6b919547759f inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a9132bae9e577ae479ddc6b919547759f">RunInTransaction</a> (Action action)</td></tr>
<tr class="memdesc:a9132bae9e577ae479ddc6b919547759f inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Executes </p>
<dl class="params"><dt>Parameters</dt><dd>
  <table class="params">
    <tr><td class="paramname">action</td><td>within a (possibly nested) transaction by wrapping it in a SAVEPOINT. If an exception occurs the whole transaction is rolled back, not just the current savepoint. The exception is rethrown. </td></tr>
  </table>
  </dd>
</dl>
 <a href="#a9132bae9e577ae479ddc6b919547759f">More...</a><br/></td></tr>
<tr class="separator:a9132bae9e577ae479ddc6b919547759f inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a920c3f7421ad1c967730228abb5915fc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a920c3f7421ad1c967730228abb5915fc">InsertAll</a> (System.Collections.IEnumerable objects)</td></tr>
<tr class="memdesc:a920c3f7421ad1c967730228abb5915fc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a920c3f7421ad1c967730228abb5915fc">More...</a><br/></td></tr>
<tr class="separator:a920c3f7421ad1c967730228abb5915fc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a62b62415941ce6486f7dfa219a69f1f1 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a62b62415941ce6486f7dfa219a69f1f1">InsertAll</a> (System.Collections.IEnumerable objects, string extra)</td></tr>
<tr class="memdesc:a62b62415941ce6486f7dfa219a69f1f1 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a62b62415941ce6486f7dfa219a69f1f1">More...</a><br/></td></tr>
<tr class="separator:a62b62415941ce6486f7dfa219a69f1f1 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a08e03803dd01aa67ee56a8e6d184c9d9 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a08e03803dd01aa67ee56a8e6d184c9d9">InsertAll</a> (System.Collections.IEnumerable objects, Type objType)</td></tr>
<tr class="memdesc:a08e03803dd01aa67ee56a8e6d184c9d9 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts all specified objects.  <a href="#a08e03803dd01aa67ee56a8e6d184c9d9">More...</a><br/></td></tr>
<tr class="separator:a08e03803dd01aa67ee56a8e6d184c9d9 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a937382b36e6726d12fe6d09f7bfb0ab6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a937382b36e6726d12fe6d09f7bfb0ab6">Insert</a> (object obj)</td></tr>
<tr class="memdesc:a937382b36e6726d12fe6d09f7bfb0ab6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a937382b36e6726d12fe6d09f7bfb0ab6">More...</a><br/></td></tr>
<tr class="separator:a937382b36e6726d12fe6d09f7bfb0ab6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1c16c3dda43037326b7f2afc6c822abd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c16c3dda43037326b7f2afc6c822abd">InsertOrReplace</a> (object obj)</td></tr>
<tr class="memdesc:a1c16c3dda43037326b7f2afc6c822abd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.  <a href="#a1c16c3dda43037326b7f2afc6c822abd">More...</a><br/></td></tr>
<tr class="separator:a1c16c3dda43037326b7f2afc6c822abd inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a19576a29af1c0891a646ff3e904f2cdc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a19576a29af1c0891a646ff3e904f2cdc">Insert</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:a19576a29af1c0891a646ff3e904f2cdc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a19576a29af1c0891a646ff3e904f2cdc">More...</a><br/></td></tr>
<tr class="separator:a19576a29af1c0891a646ff3e904f2cdc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a812215a88043259b6a107994756000ae inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a812215a88043259b6a107994756000ae">InsertOrReplace</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:a812215a88043259b6a107994756000ae inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one. If a UNIQUE constraint violation occurs with some pre-existing object, this function deletes the old object.  <a href="#a812215a88043259b6a107994756000ae">More...</a><br/></td></tr>
<tr class="separator:a812215a88043259b6a107994756000ae inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a3ab0fde4b10c4b492b2f5f64535c6d66 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a3ab0fde4b10c4b492b2f5f64535c6d66">Insert</a> (object obj, string extra)</td></tr>
<tr class="memdesc:a3ab0fde4b10c4b492b2f5f64535c6d66 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#a3ab0fde4b10c4b492b2f5f64535c6d66">More...</a><br/></td></tr>
<tr class="separator:a3ab0fde4b10c4b492b2f5f64535c6d66 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab88782cd2d5c77bb14d6a17baf7c49bc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab88782cd2d5c77bb14d6a17baf7c49bc">Insert</a> (object obj, string extra, Type objType)</td></tr>
<tr class="memdesc:ab88782cd2d5c77bb14d6a17baf7c49bc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Inserts the given object and retrieves its auto incremented primary key if it has one.  <a href="#ab88782cd2d5c77bb14d6a17baf7c49bc">More...</a><br/></td></tr>
<tr class="separator:ab88782cd2d5c77bb14d6a17baf7c49bc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ae4effee772569a47256bcb5f8764eabc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ae4effee772569a47256bcb5f8764eabc">Update</a> (object obj)</td></tr>
<tr class="memdesc:ae4effee772569a47256bcb5f8764eabc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.  <a href="#ae4effee772569a47256bcb5f8764eabc">More...</a><br/></td></tr>
<tr class="separator:ae4effee772569a47256bcb5f8764eabc inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab474a534faebfec1288672ef4e4f2140 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab474a534faebfec1288672ef4e4f2140">Update</a> (object obj, Type objType)</td></tr>
<tr class="memdesc:ab474a534faebfec1288672ef4e4f2140 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all of the columns of a table using the specified object except for its primary key. The object is required to have a primary key.  <a href="#ab474a534faebfec1288672ef4e4f2140">More...</a><br/></td></tr>
<tr class="separator:ab474a534faebfec1288672ef4e4f2140 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1a95399fe5d61f8bbb56e36eac38d467 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1a95399fe5d61f8bbb56e36eac38d467">UpdateAll</a> (System.Collections.IEnumerable objects)</td></tr>
<tr class="memdesc:a1a95399fe5d61f8bbb56e36eac38d467 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Updates all specified objects.  <a href="#a1a95399fe5d61f8bbb56e36eac38d467">More...</a><br/></td></tr>
<tr class="separator:a1a95399fe5d61f8bbb56e36eac38d467 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a55234164e36bc4abcb086e197f25e436 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a55234164e36bc4abcb086e197f25e436">Delete</a> (object objectToDelete)</td></tr>
<tr class="memdesc:a55234164e36bc4abcb086e197f25e436 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes the given object from the database using its primary key.  <a href="#a55234164e36bc4abcb086e197f25e436">More...</a><br/></td></tr>
<tr class="separator:a55234164e36bc4abcb086e197f25e436 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a0d4046198236b8c96b0bf50593f592a6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a0d4046198236b8c96b0bf50593f592a6">Delete&lt; T &gt;</a> (object primaryKey)</td></tr>
<tr class="memdesc:a0d4046198236b8c96b0bf50593f592a6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes the object with the specified primary key.  <a href="#a0d4046198236b8c96b0bf50593f592a6">More...</a><br/></td></tr>
<tr class="separator:a0d4046198236b8c96b0bf50593f592a6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abed406a2cd17e1e360b79924a749b67c inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abed406a2cd17e1e360b79924a749b67c">DeleteAll&lt; T &gt;</a> ()</td></tr>
<tr class="memdesc:abed406a2cd17e1e360b79924a749b67c inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Deletes all the objects from the specified table. WARNING WARNING: Let me repeat. It deletes ALL the objects from the specified table. Do you really want to do that?  <a href="#abed406a2cd17e1e360b79924a749b67c">More...</a><br/></td></tr>
<tr class="separator:abed406a2cd17e1e360b79924a749b67c inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ad9e1e281245e83dbe9c5303eaefe95f6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ad9e1e281245e83dbe9c5303eaefe95f6">Dispose</a> ()</td></tr>
<tr class="separator:ad9e1e281245e83dbe9c5303eaefe95f6 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a74160304a4a218b7508220106eeb10d0 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a74160304a4a218b7508220106eeb10d0">Close</a> ()</td></tr>
<tr class="separator:a74160304a4a218b7508220106eeb10d0 inherit pub_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table><table class="memberdecls">
<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="inherited"></a>
Additional Inherited Members</h2></td></tr>
<tr class="inherit_header pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td colspan="2" onclick="javascript:toggleInherit('pro_methods_class_s_q_lite_1_1_s_q_lite_connection')"><img src="closed.png" alt="-"/>&#160;Protected Member Functions inherited from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLite.SQLiteConnection</a></td></tr>
<tr class="memitem:a7535db6cca83fcde078fa4340b32e982 inherit pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">virtual <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a7535db6cca83fcde078fa4340b32e982">NewCommand</a> ()</td></tr>
<tr class="memdesc:a7535db6cca83fcde078fa4340b32e982 inherit pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Creates a new <a class="el" href="class_s_q_lite_1_1_s_q_lite_command.html">SQLiteCommand</a>. Can be overridden to provide a sub-class.  <a href="#a7535db6cca83fcde078fa4340b32e982">More...</a><br/></td></tr>
<tr class="separator:a7535db6cca83fcde078fa4340b32e982 inherit pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ab5e33e84b34867c48d1578d2890ff7e7 inherit pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">virtual void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ab5e33e84b34867c48d1578d2890ff7e7">Dispose</a> (bool disposing)</td></tr>
<tr class="separator:ab5e33e84b34867c48d1578d2890ff7e7 inherit pro_methods_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="inherit_header properties_class_s_q_lite_1_1_s_q_lite_connection"><td colspan="2" onclick="javascript:toggleInherit('properties_class_s_q_lite_1_1_s_q_lite_connection')"><img src="closed.png" alt="-"/>&#160;Properties inherited from <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html">SQLite.SQLiteConnection</a></td></tr>
<tr class="memitem:a504b348bb83df3b51fb49937db4d7804 inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top"><a class="el" href="_s_q_lite_8cs.html#a0137d4c5059675164f7580c64441f40c">Sqlite3DatabaseHandle</a>&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a504b348bb83df3b51fb49937db4d7804">Handle</a><code> [get, set]</code></td></tr>
<tr class="separator:a504b348bb83df3b51fb49937db4d7804 inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a18b410ed380268c16bb9bdb47b5ad44b inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a18b410ed380268c16bb9bdb47b5ad44b">DatabasePath</a><code> [get, set]</code></td></tr>
<tr class="separator:a18b410ed380268c16bb9bdb47b5ad44b inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af925b9fddec261394ab29fbbaa25d9a0 inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af925b9fddec261394ab29fbbaa25d9a0">TimeExecution</a><code> [get, set]</code></td></tr>
<tr class="separator:af925b9fddec261394ab29fbbaa25d9a0 inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:af9e92ae222dba65b2ab761139531118a inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#af9e92ae222dba65b2ab761139531118a">Trace</a><code> [get, set]</code></td></tr>
<tr class="separator:af9e92ae222dba65b2ab761139531118a inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a1c24728cf622f060629aac155e2afcaa inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a1c24728cf622f060629aac155e2afcaa">StoreDateTimeAsTicks</a><code> [get, set]</code></td></tr>
<tr class="separator:a1c24728cf622f060629aac155e2afcaa inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:abb2b70df282aa2f1af07789db65db1dd inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">TimeSpan&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abb2b70df282aa2f1af07789db65db1dd">BusyTimeout</a><code> [get, set]</code></td></tr>
<tr class="memdesc:abb2b70df282aa2f1af07789db65db1dd inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sleep multiple times until a total time of <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#abb2b70df282aa2f1af07789db65db1dd" title="Sets a busy handler to sleep the specified amount of time when a table is locked. The handler will sl...">BusyTimeout</a> has accumulated.  <a href="#abb2b70df282aa2f1af07789db65db1dd">More...</a><br/></td></tr>
<tr class="separator:abb2b70df282aa2f1af07789db65db1dd inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:ac0c3b1e8f8060ef9777fac08751d159e inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">IEnumerable&lt; <a class="el" href="class_s_q_lite_1_1_table_mapping.html">TableMapping</a> &gt;&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#ac0c3b1e8f8060ef9777fac08751d159e">TableMappings</a><code> [get]</code></td></tr>
<tr class="memdesc:ac0c3b1e8f8060ef9777fac08751d159e inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Returns the mappings from types to tables that the connection currently understands.  <a href="#ac0c3b1e8f8060ef9777fac08751d159e">More...</a><br/></td></tr>
<tr class="separator:ac0c3b1e8f8060ef9777fac08751d159e inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
<tr class="memitem:a9450dfedb603c08eb75f57f36db41d9b inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memItemLeft" align="right" valign="top">bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a9450dfedb603c08eb75f57f36db41d9b">IsInTransaction</a><code> [get]</code></td></tr>
<tr class="memdesc:a9450dfedb603c08eb75f57f36db41d9b inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="mdescLeft">&#160;</td><td class="mdescRight">Whether <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#aba3becdb524808bd49f349587f1b7049" title="Begins a new transaction. Call Commit to end the transaction. ">BeginTransaction</a> has been called and the database is waiting for a <a class="el" href="class_s_q_lite_1_1_s_q_lite_connection.html#a2c8187a19b5065f6b23c079e7cca29fe" title="Commits the transaction that was begun by BeginTransaction. ">Commit</a>.  <a href="#a9450dfedb603c08eb75f57f36db41d9b">More...</a><br/></td></tr>
<tr class="separator:a9450dfedb603c08eb75f57f36db41d9b inherit properties_class_s_q_lite_1_1_s_q_lite_connection"><td class="memSeparator" colspan="2">&#160;</td></tr>
</table>
<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
<div class="textblock">
<p>Definition at line <a class="el" href="_s_q_lite_async_8cs_source.html#l00455">455</a> of file <a class="el" href="_s_q_lite_async_8cs_source.html">SQLiteAsync.cs</a>.</p>
</div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
<a class="anchor" id="a49c8bfc343c53c30aa6195395958ffe2"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">SQLite.SQLiteConnectionWithLock.SQLiteConnectionWithLock </td>
          <td>(</td>
          <td class="paramtype"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_string.html">SQLiteConnectionString</a>&#160;</td>
          <td class="paramname"><em>connectionString</em></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_async_8cs_source.html#l00459">459</a> of file <a class="el" href="_s_q_lite_async_8cs_source.html">SQLiteAsync.cs</a>.</p>

</div>
</div>
<h2 class="groupheader">Member Function Documentation</h2>
<a class="anchor" id="ad38e795a2b94ecd709b9b60e2c4d3e4e"></a>
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">IDisposable SQLite.SQLiteConnectionWithLock.Lock </td>
          <td>(</td>
          <td class="paramname"></td><td>)</td>
          <td></td>
        </tr>
      </table>
</div><div class="memdoc">

<p>Definition at line <a class="el" href="_s_q_lite_async_8cs_source.html#l00464">464</a> of file <a class="el" href="_s_q_lite_async_8cs_source.html">SQLiteAsync.cs</a>.</p>

</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li><a class="el" href="_s_q_lite_async_8cs_source.html">SQLiteAsync.cs</a></li>
</ul>
</div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
  <ul>
    <li class="navelem"><a class="el" href="namespace_s_q_lite.html">SQLite</a></li><li class="navelem"><a class="el" href="class_s_q_lite_1_1_s_q_lite_connection_with_lock.html">SQLiteConnectionWithLock</a></li>
    <li class="footer">Generated on Thu Dec 26 2013 14:21:50 for SystemSharp by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.6 </li>
  </ul>
</div>
</body>
</html>
